import pandas as pd
from _stock_basic import get_data

if __name__ == '__main__':
    excel = pd.read_excel("a20250808_930955_3thr_2025_.xlsx")
    print(excel.head())
    data = get_data()
    print(data.head())

    data = data[['ts_code', 'name', 'industry']]
    print(data)

    merge = pd.merge(excel, data, how='left', on='ts_code')
    merge.to_excel('merge.xlsx')


